Prerequisites

Before designing a task with HP NonStop SQL/MP as an ODBC Target, the following prerequisites must be met:

• All source tables and their indexes must already exist on the target database.

• The default name for the Replicate Apply Exceptions table (attrep_apply_exceptions) is not compliant with HP NonStop SQL/MP table naming conventions which dictate that table names cannot exceed 8 characters or contain non-alphanumeric characters. To resolve this conflict, you need to add the following entry to your NAVMAP file or create a new NAVMAP file (The NAVMAP file is located in the subvolume where ARC is installed):

  Syntax:

  [SQLMP]

  attrep_apply_exceptions= \machine_name.$volume_name.subvolume_name.atreapex

  You also need to manually create the Apply Exceptions table on the HP NonStop SQL/MP target before starting the task. The table should be named atreapex and should contain the following columns:

  Column name data types

  Column name	Data type
  TASK_NAME	Varchar(128)
  TABLE_OWNER	Varchar(128)
  TABLE_NAME	Varchar(128)
  ERRORTIME	Datetime year to fraction
  STATEMENT	Varchar(1000)
  ERROR	Varchar(1000)

• If you intend to enable the Replicate Store Changes option, you need to manually create the audit table on the HP NonStop SQL/MP target before starting the task.

  Information note

  This also requires you make the following changes in the Store Changes Settings tab:

  1. Select Audit table from the Store changes drop-down list.

  2. Change the default audit table name from attrep_audit_table to atreauta.

  Create a table named atreauta with the following parameters:

  Parameter data types

  Column Name	Data Type
  *task_name	Varchar(110)
  *stream_position	Varchar(128)
  change_seq	Varchar(35)
  change_oper	Varchar(1)
  schema_name	Varchar(128)
  table_name	Varchar(128)
  operation	Varchar(12)
  transaction_id	Varchar(32)
  timestamp	Timestamp
  change_record	Varchar(1000)
  bu_change_record	Varchar(1000)

  Information note

  : You also need to create a Unique Index consisting of the task_name and stream_position columns (marked with an asterisk above).